---
title: "Mysql Comamnd Line Client"
date: 2019-9-18
categories:
- mysql
tags:
---

<div id="content">
<div id="table-of-contents">
<h2>Table of Contents</h2>
<div id="text-table-of-contents">
<ul>
<li><a href="#org6127d8c">保存凭据: mysql_config_editor</a>
<ul>
<li><a href="#org294131f">打印所有的凭据</a></li>
<li><a href="#orga98113c">新增或修改凭据</a></li>
<li><a href="#org5658c04">使用保存的凭据登录</a></li>
</ul>
</li>
</ul>
</div>
</div>
<div class="outline-2" id="outline-container-org6127d8c">
<h2 id="org6127d8c">保存凭据: mysql_config_editor</h2>
<div class="outline-text-2" id="text-org6127d8c">
</div>
<div class="outline-3" id="outline-container-org294131f">
<h3 id="org294131f">打印所有的凭据</h3>
<div class="outline-text-3" id="text-org294131f">
<p>
mysql_config_editor print –all
</p>
</div>
</div>
<div class="outline-3" id="outline-container-orga98113c">
<h3 id="orga98113c">新增或修改凭据</h3>
<div class="outline-text-3" id="text-orga98113c">
<p>
mysql_config_editor set –login-path=&lt;别名&gt; –host=&lt;server_host&gt; –port=3306 –user=root –password
</p>
<p>
password后没有参数，命令行将提示输入密码。
</p>
</div>
</div>
<div class="outline-3" id="outline-container-org5658c04">
<h3 id="org5658c04">使用保存的凭据登录</h3>
<div class="outline-text-3" id="text-org5658c04">
<p>
mysql –login-path=&lt;别名&gt;
</p>
<p>
mycli也能使用这个选项，使用mysql client保存的凭据
</p>
</div>
</div>
</div>
</div>
<div class="status" id="postamble">
<p class="date">Date: 2019-9-18</p>
<p class="author">Author: gdme1320</p>
<p class="validation"><a href="http://validator.w3.org/check?uri=referer">Validate</a></p>
</div>
